query=
-- _c_empresa.php inicializar()
SELECT *
FROM empresa
WHERE 1=1
AND web = 100
AND estado = 'A'
num_tuplas=
95
query=
-- _c_zonas.php / cargar_metazonas_superzonas_zonas()
SELECT
metazonas.cod_metazona
-- 20131122 avv
,metazonas.cod_provincia
,metazonas.denom_metazona
,superzonas.cod_superzona
,superzonas.denom_superzona
-- 20131129 rbz [1872-1873]
,metazonas.coord_latitud
,metazonas.coord_longitud
,metazonas.area_coordenadas
,metazonas.zoom_mapa
FROM
metazonas
,superzonas
WHERE
-- 20130902 rbz [1826-1827]
-- superzonas.web = '100'
superzonas.web = 0
AND metazonas.cod_metazona = superzonas.cod_metazona
AND superzonas.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99)
-- 20140116 rbz [20140116a].
-- [20180426b]
ORDER BY
metazonas.cod_metazona
,superzonas.cod_superzona
;
num_tuplas=
9229
query=
-- _c_zonas.php cargar_zonas()
SELECT
zonas.cod_metazona
,zonas.cod_superzona
,zonas.cod_maxizona
,zonas.cod_zona
,zonas.denom_zona
FROM
zonas
WHERE
-- 20130902 rbz [1826-1827]
-- web = '100'
web = 0
AND zonas.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99)
-- //20130425a rbz [20130425a] Cuidado! Esto podrá mejorar el rendimiento, pero al acceder al detalle de propiedad, el formulario de búsqueda avanzado queda incompleto! (le faltan todas las zonas menos la de la propiedad consultada
-- AND (zonas.cod_superzona = '' OR '' = '')
AND zonas.indicador > 0
-- 20140116 rbz [20140116a]..
-- [20180426b]
ORDER BY
zonas.cod_superzona
,zonas.cod_zona
;
num_tuplas=
15733
query=
-- _c_zonas.php cargar_subzonas()
SELECT
subzonas.cod_metazona
,subzonas.cod_superzona
,subzonas.cod_zona
,subzonas.cod_subzona
,subzonas.denom_subzona
FROM
subzonas
WHERE
web = 0
AND subzonas.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99)
-- 20140116 rbz [20140116a]....
-- [20180426b]
ORDER BY
subzonas.cod_metazona
,subzonas.cod_superzona
,subzonas.cod_zona
;
num_tuplas=
977
España. Property search.
Cargando...
query=
-- _f_propiedades.php listar_propiedades()
SELECT
*
FROM propiedad
WHERE
web = 100 -- std
-- cond_empresa
AND cod_empresa != 0 -- p.
AND (
-- propiedades de empresas no excluidas de MLS
(
(web, cod_empresa) NOT IN (
SELECT web_cap, cod_empresa_cap
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 0
AND cod_propiedad IS NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 0
AND cod_propiedad IS NOT NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS a nivel global (por usuario administrador de MLS 20230626a)
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE estado = 'X'
)
)
)
-- 20141219 rbz [MLSxx] Inclusión propiedades de Re-max e In-Max en LP360
-- nop!
AND propiedad.cod_oficina = 0
AND ( cod_empresa != 1 OR 1=2 ) -- ceidemo 1 &&
AND propiedad.cod_propiedad NOT IN (0)
AND (
( propiedad.estado IN ('A','O','B') )
|| ( propiedad.estado IN ('V','R') AND fecha_ult_mod > '20240502' AND NOT 1=2 ) -- Vendidas y alquiladas se muestran en webs publicas n_dias despues de la operacion
|| ( propiedad.estado = 'V' AND 0 =1 )
|| ( propiedad.estado = 'R' AND 0 =1 )
|| ( propiedad.estado = '3' AND 0 =1 )
|| ( propiedad.estado = '4' AND 0 =1 )
|| ( propiedad.estado = 'C' AND 0 =1 )
-- || ( propiedad.estado = 'P' AND 1=2 ) -- Prospeccion
|| ( propiedad.estado = 'P' AND 0 =1 )
|| ( propiedad.estado = 'B' AND 0 =1 )
)
AND -- propiedades no publicadas
(
propiedad.publicar IN ('S','P') -- TIPO_WEB_PORTAL
)
AND (
( propiedad.tipo_operacion = '' ) -- El tipo_operacion de la propiedad coincide con el indicado por el usuario
|| ( propiedad.tipo_operacion IN ('V','A') && '' = 'X' ) -- El tipo_operacion de la propiedad es Venta o Alquiler y el indicado por el usuario es X
|| ( propiedad.tipo_operacion = 'X' && ('' = 'V' || '' = 'A') ) -- El tipo_operacion de la propiedad es X y el indicado por el usuario es Venta o Alquiler
|| ( '' = '' ) -- El usuario no ha seleccionado tipo_operacion, mostramos todo
-- [20180806d]
|| ( propiedad.tipo_operacion IN ('H') && '' = 'C' ) -- El tipo_operacion de la propiedad es Alquiler vacacional y el indicado por el usuario es C (alquiler de corta duracion)
)
AND (
cod_valoracion = ''
||
'' = ''
)
-- cond_pais
-- cond_zonas
AND ( propiedad.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99) )
-- 20180806d
-- cond_metazonas_portales
-- cond_metazonas_portales: ERROR!! NO OBSERVADO PORTAL 100
AND (
( propiedad.metatipo_propiedad = '' ) -- el metatipo_propiedad es el seleccionado
||
( '' = '' )
)
AND (
( propiedad.tipo_propiedad IN (0) ) -- el tipo de propiedad es el seleccionado
||
( ( '0' = '' || '0' = 0 ) ) -- 20120820 rbz Incluimos negocios en home, además es necesario para que salgan cuando no se indica tipo_propiedad && tipo_propiedad < 200 ) -- No se seleccionó tipo_propiedad (página inicial) No pintamos parcelas, negocios...
||
( ( '0' = '' || '0' = 0 ) && '' = 3 ) -- inversiones
)
AND ( propiedad.superficie >= '' || '' = '' )
AND ( propiedad.superficie <= '' || '' = '' )
AND ( propiedad.superficie_util >= '' || '' = '' )
AND ( propiedad.superficie_util <= '' || '' = '' )
AND ( propiedad.superficie_parcela >= '' || '' = '' )
AND ( propiedad.superficie_parcela <= '' || '' = '' )
AND propiedad.fecha_alta <= '20240517'
AND
( -- Usuario busca Venta/Alquiler (o no selecciona tipo_operacion)
-- propiedad.tipo_operacion IN ('V','A','X')
( propiedad.precio_pvp <= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_pvp >= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler <= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler >= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
)
-- 20131223 rbz
-- 20130128 rbz
-- 20130916 rbz [20130131a]
-- 20130506 rbz
-- [20160430a]
-- 20131028 rbz [20131028a]
-- 20131220 rbz [20131220a]
-- 20130514 rbz [20130514a]
-- 20180305b
-- [3370-4320]
AND propiedad.num_fotos >= 1
AND cod_propiedad NOT IN (1111) -- propiedades_especialitas_excluidas
ORDER BY
CASE
WHEN web = 100 AND cod_empresa = 0 THEN 1 -- propiedades de la propia empresa-
ELSE 9
END,
CASE
WHEN web = 100 AND cod_empresa = 0 THEN prioridad -- propiedades de la propia empresa
-- ELSE 999 -- no deberia ser -1?
ELSE -1
END DESC
, -- 20220315 rbz Añado criterio prioridad (Thorsgren quería para que sus propiedades aparecieran antes que resales)
-- 20220315 rbz Añado este criterio para que las propiedades de MLS aparezcan ordenadas según la empresa asociada
cod_propiedad DESC -- 11
LIMIT 24 -- 24 = 24 - %
-- num_prop_slide= grupo_registros=2 num_max_propiedades_x_pagina=24
OFFSET 48 -- 3 offp
num_tuplas=
24
Beautiful turnkey villa project in Montemayor. Construction ready to start with approved licence. The project was designed for a 5 bedroom-7 bathroom villa over 3 levels.
This charming villa, just a few steps from the beach is located in the heart of one of the most sought-after urbanisations of Marbella's Golden Mile. In the past, The owners have enjoyed family life in this house all year round and therefore it was conditioned to prevent humidity and other issues. Despite its great condition, it represents an exciting opportunity for a renovation project.
The basement holds great potential, offering opportunities for transformation into a game room, home cinema and more.
There is room for a swimming pool in the garden.
Casa Leo is an exquisite four bedroom property that sparkles with luxury, is sold fully furnished and is distributed over three levels. This townhouse has been completely renovated. It is located in Aloha Gardens, a beautiful gated development with lush gardens, three swimming pools and surrounded by trendy restaurants and cafes; it is at the foot of the golf valley, in the heart of Nueva Andalucía and just minutes away from Puerto Banús and Marbella.
The ground floor consists of the living room, the open plan kitchen, furnished and equipped with Miele appliances. This space is connected to the terrace and garden with its barbecue area; a spacious and very luminous place thanks to its large windows. On the ground floor there is also a bedroom.
On the first floor there are the rest of the bedrooms. The master bedroom has an en-suite bathroom and its own terrace.
The top floor is to be enjoyed! A magnificent terrace, with swimming pool, sauna, bar and fire pit, this terrace is a marvel. The property has a garage parking space.
There are so many details, luxuries, textures... You must see it for yourself. Call us now to visit.
!Reduced for quick sale!!!!Stunning Ground Floor Apartment with Private Garden and Pool Access!!
Welcome to your dream home! This beautiful ground floor apartment offers a harmonious blend of comfort, elegance, and convenience. Here's why you'll fall in love with it:
Spacious and Bright: As you step inside, you'll be greeted by an unusually large lounge-dining area that bathes in natural light. The open layout creates a sense of freedom and relaxation.
Modern Kitchen: The fully fitted modern kitchen is a culinary haven. Imagine preparing meals surrounded by sleek appliances and ample counter space. Plus, there's a separate utility-laundry room for added convenience.
Two Luxurious Bedrooms: Both double bedrooms come with fitted wardrobes, ensuring plenty of storage space. Wake up to serene garden views and enjoy the tranquility of your private oasis.
Sea Views from Your Terrace: Step out onto your covered terrace, where the sparkling Mediterranean Sea unfolds before you. Sip your morning coffee or host intimate gatherings in this exclusive outdoor space.
Impeccably Maintained Gardens: The community's lush gardens are meticulously cared for by a dedicated gardener. Stroll through fragrant blooms and follow the path directly to the inviting pool—a refreshing escape on warm days.
Fully Furnished: Move right in! This apartment comes fully furnished, allowing you to start enjoying the coastal lifestyle immediately.
Private Carparking Space: No more parking woes! Your designated spot awaits, accessible via a secure gate entrance.
La Mairena: A Hidden Gem: Nestled just outside Marbella, La Mairena offers the best of both worlds. Explore charming shops, dine at exquisite restaurants, and discover an internationally renowned school. Golf enthusiasts will appreciate the nearby golf course and other sports facilities.
Short Drive to the Coast: Within minutes, you can have your toes in the sand, breathing in the salty ocean breeze. The coast beckons, and it's all conveniently close.
Don't miss out on this exceptional opportunity. Contact us today to schedule a viewing and make this apartment your own!!
Investment opportunity! Apartment on the second floor with elevator, 2 bedrooms, a separate kitchen and is partially furnished. A beautiful wooden platform has recently been installed, which gives it a touch of elegance and warmth. Strategically located in La Cuesta, this property is close to the tram stop, making your travels easier. In addition, you will have at your disposal services such as Mercadona and other shops just a few steps away. And that's not all! The price includes a parking space, a real advantage in a building without parking spaces. Don't miss this opportunity to make it your home. Call now for more information!
Are you looking for your home to move into? Do you want to invest in a property where you don't have to do anything?
You're in luck, look no further we have it for you.
It is in Levante in the Edisol neighborhood, a consolidated area with all kinds of services at hand such as supermarkets, schools, close to the city center and with easy access to the highway.
When you enter you will feel that you have arrived at home, the home you always wanted. With wooden floors and windows that offer you an unmatched feeling.
For hot days, you have air conditioning throughout the apartment which consists of two bedrooms, living room and kitchen. Also some little secrets that you will have to discover if you visit with us.
And if you need it, we offer you customized financing with the best conditions.
Don't miss the opportunity to live in this cozy renovated apartment in the Levante - Lepanto - Edisol area!
To comply with current regulations, we have the D.I.A. Abbreviated Information Document available to the client. At your disposal if you need it. The prices indicated do not expire but may be subject to change without prior notice. PURCHASE EXPENSES will be according to law (Notary, Registry and taxes) and are not included in the indicated price. Agency Fees are NOT included.
Unless the offer specifies it, the price of the property does not include the content: furniture, appliances, clothing, tools, vehicles or any article or decorative element that may appear in the images.
This announcement is not binding and may contain errors.
SE ALQUILA Good flat in Aguadulce Very bright, consists of two dormitories with built-in wardrobes, large living room with access to the terrace, a complete bathroom. Lavadero. Cooking amueblada. Swimming pool, garage. Amueblado, Children's Park. Ideal for holidays in Verano and available from SEPTEMBER TO JUNE.
Reference:
493716
Size:
85m²
Usable size:
70m²
Bedrooms:
2
Bathrooms:
1
Furnished:
Fully furnished
Garage:
Comunitary
Garage type:
Carport
Swimming pool:
Comunitary
Floor:
1st
Built-in cupboards:
Yes
Independent dining room:
Yes
Furnished kitchen:
Furnished with appliances
Kitchen type:
Independent
Orientation:
Southeast, South, Southwest
Location:
Beachfront
Walls:
Flat
Floors:
Porcelain stoneware
Storage room:
No
Lift:
Yes
Urbanization:
Private
Building year:
2010 (14 year/s)
Condition:
Good
Equipment:
Refrigerator, Washing machine, Video intercom, Ceramic hob
Fabulous semi-detached house in an urbanization of Las Lagunas de Mijas almost in the El Hornillo area.
It is a three-story semi-detached house plus a large solarium with fabulous views of the sea and the surrounding area.
It consists of 4 bedrooms, 2 bathrooms + 1 toilet, independent equipped kitchen, three terraces, private garden and own parking area at the entrance.
The semi-detached house is in good condition and is delivered furnished with very good quality furniture, ready to move into.
The living area is about 180 m2 built, to which must be added the solarium, the terraces, the garden and the private parking area.
It is located in a quiet area within an urbanization with a pool and garden.
2 bedroom apartment with sea views in El Pinillo - Torremolinos
Charming home located in the Pinillo area, with a privileged corner position. Terrace with exceptional luminosity throughout the day.
This home has an American kitchen open to the living room, two terraces, two bedrooms (one with a built-in wardrobe) and a bathroom.
The living room has reversible hot/cold air conditioning.
This property has community pools, tennis court, barbecue area, summer bar and large garden areas.
Community €140 per month (water included), ibi €200
Beach/Sea: 4min by car
Malaga Airport: 15min by car
Direct access to the highway, shopping center and all kinds of services: bus, schools, institutes, supermarkets, pharmacies, bars, restaurants.
Opportunity, brand new renovated!! top floor facing the sea. stunning beach views. 15m2 L-shaped terrace, two-bedroom house with built-in wardrobes and two bathrooms, one of them en suite. Community area with large swimming pools and green areas. Storage parking included.
elevator, air conditioning, brand new renovated, sea views, community €120-month
Exciting Opportunity a very competitively priced spacious 2-Bedroom apartment in Aloha, Nueva Andalucia!
Discover a bright, quality apartment nestled in a premier gated community. Step into an inviting entrance hallway with guest toilet leading to a generously sized lounge dining room, offering direct access to a charming terrace with views of lush communal gardens and pool.
Enjoy seamless flow to a fully fitted kitchen from both dining area and hallway. Two bedrooms and two fully fitted bathrooms with underfloor heating for added comfort.
Experience 5-star amenities including gym, sauna, steam room, and indoor pool. Ideal for both personal retreat and rental investment, with tourist license in place.
Mortgage options available from a top Spanish bank. Plus, benefit from three parking spaces and a spacious storage room included with the property.
Don't miss out on this exceptional opportunity!
Discover the epitome of luxury living in this stunning villa nestled in a prestigious urbanizacion. Boasting a total of five bedrooms and three bathrooms, this property offers a spacious and comfortable retreat for your family and guests.
The main house features three inviting bedrooms, complemented by two elegant bathrooms. Step into the heart of the home, where an open-concept living, dining, and kitchen area awaits. Natural light floods the space, highlighting the modern design and premium finishes. Imagine entertaining friends and family in this stylish setting, with seamless transitions from indoors to the captivating terrace.
The terrace itself is a masterpiece, providing breathtaking sea views that stretch as far as the eye can see. Whether you're enjoying a morning coffee or hosting an evening soiree, this outdoor space is destined to become your favorite spot. Take a refreshing dip in the inviting pool or simply unwind in the tranquility of the surroundings.
For additional comfort and privacy, the property includes a guest house with two bedrooms and a well-appointed bathroom. Perfect for accommodating visitors or creating a dedicated space for work or hobbies.
Convenience meets luxury with the inclusion of a garage, ensuring secure parking for your vehicle. The mature garden adds a touch of nature to the property, creating a serene atmosphere that enhances the overall charm.
Seize the opportunity to own this exceptional villa in Urbanizacion Peña Blanquilla – where every detail is crafted for a lifestyle of elegance and relaxation. Contact us now to make this dream property your reality.
Detached Villa, Mijas, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 185 m², Terrace 65 m².
Setting : Town, Country, Close To Golf, Close To Shops, Close To Town, Close To Forest, Urbanisation.
Orientation : South East, South, South West.
Condition : Excellent.
Pool : Private.
Climate Control : Air Conditioning.
Views : Sea, Mountain, Port, Country, Panoramic, Pool, Courtyard.
Features : Covered Terrace, Near Transport.
Furniture : Part Furnished.
Kitchen : Fully Fitted.
Garden : Private.
Parking : Garage.
For sale east of Malaga, a unique and charming estate with nearly 30,000 square meters of land awaits its new owner.
This exceptional & stunning property exudes a castle-like allure and is situated in a peaceful, secluded area in Cajiz, just 26 kilometers east of Malaga.
Upon entering the property through an automated gate, a short private drive leads you to the expansive driveway, offering ample parking options including two carports and a spacious garage. The outdoor space is a sight to behold, featuring olive trees that can yield 1000 liters of oil per year,if someone is up for the task, as well as many various fruit trees.
Nestled below the finca, the swimming pool provides a private retreat, while two very cozy cottages accommodate guests.
The finca itself boasts numerous charming and clever elements, such as a cozy lounge, the amazing mountain views, a wine cellar, and a luxurious ensuite bedroom with Andalusian and Moroccan influences.
The grand entrance hall sets the tone for the property, leading to a remarkable stone pathway that unveils a private wine cellar that can easily be converted into an additional bedroom, as this property have another wine cellar around the pool area.
A spiral staircase ascends to the main bedroom with a balcony offering serene bird-filled mood and a charming bathroom featuring a Moroccan-style bathtub.
The spacious living room opens up to a delightful patio overlooking the picturesque mountains, while a few steps lead to a second bedroom with lovely ceiling beams and an adjacent bathroom.
Descending a few steps from the hall, you'll find the open kitchen and dining area, exuding modern charm with a cozy fireplace and access to the outdoor terraces.
Beyond the terraces lies the pool area, a workshop shed, two cottages, and an underground wine cellar crafted by the owner, complete with a well.
This southfaced property, built in 1994, is filled with unique stories embodied in every nook and cranny. Surrounded by vast fields yet conveniently located just a short drive from the beach, shops, and restaurants, this finca offers a perfect blend of tranquility and accessibility.
Offered at €880,000, this estate comprises three bedrooms (can easy be 4 or 5) , three bathrooms, 230 square meters of built area, 195 square meters of usable space, and a sprawling 29721 square meters of land with fruit trees.
Additionally, it features three private water wells and boasts a prime location just one kilometer from the motorway and three kilometers from the beach.
Property tax is 341 euros a year
Independent 3-bedroom apartment with a large patio.
This home consists of a large living area with a fireplace, the fully fitted kitchen sits next to the living room and has the chance to be converted into an open plan.
Then three comfortable bedrooms, the master with an en-suite bathroom and nice views toward the mountains of Benahavís and the football field.
One level below there is a large patio with a covered terrace and a second dining area where you can enjoy family reunions and events.
This lovely 3 bedroom townhouse is located in lower Calahonda with everything on your door step. On the front of the house is a private car parking. There is a small terrace. Walking in we have a guest toilet, a good size enclosed kitchen and a living room with fire place. It leads out on to a large, with glass curtains, enclosed terrace. On the first floor are three bedrooms with two bathroom of which one en-suite. The urbanization is gated and has a good size pool and lovely gardens. The bars, restaurants, supermarkets and stores are within a couple of minutes walk. The beach you reach within a 5 minute walk. Great location!
Beachfront complex, Estepona, New Golden Mile. Fully renovated double semidetached townhouse located in a front line beach complex that resembles a fishing village, full of character and tradition! The location is fantastic, 60 meters from the promenade & the Mediterranean sea and only 5 minutes away from Estepona center and 10 minutes away from Puerto Banus. Set in a peaceful environment where you can hear the waves of the sea. There is a fabulous beach restaurant 50 meters away. The property was completely renovated in 2022, Spanish/Scandinavian Style. The terraces have been very well insulated and new double glazed windows have been installed.
The house comprises a total of 5 bedrooms, 5 bathrooms (2 bedroom and 2 bathroom on the ground level!), a large fully fitted kitchen, a nice living room and a beautiful patio for entertaining. Storage rooms. On the first floor you will find 3 double bedrooms with en-suite bathrooms, and a superb roof top terrace with loads of privacy and panoramic views to the sea. Viewing are highly recommended. The terrace also contains a nice small pool for a relaxing dip. Fabulous sea views from the upstairs terraces. A newly built promenade and a bus stop only a walk away so a car is not always necessary.
A semi-detached villa has 4 bedromms with a unique layout spread across three floors is available for sale. Features include a spacious living room, garden, kitchen, three bedrooms, two full bathrooms, a garage, office space, communal garden areas, and a swimming pool. Ideal for comfort and practicality, equipped with built-in closets and a storage room. Contact for more details and viewing.
This charming semi-detached villa is a hidden gem waiting to be discovered. As you step inside, you are greeted by a spacious living room that offers the perfect setting for relaxation and entertainment. The kitchen is a chef's dream, with modern appliances and ample counter space for culinary creations.
Venturing upstairs, you will find three cozy bedrooms, each offering a tranquil retreat at the end of a long day.
The villa also boasts a garage, ideal for keeping your vehicles secure, as well as office space for those who work from home or need a quiet area for creativity. The communal garden areas are perfect for enjoying the outdoors, while the swimming pool offers a refreshing escape on warm days.
With built-in closets and a storage room, this villa seamlessly combines comfort and practicality. Whether you are looking for a peaceful sanctuary or a place to entertain friends and family, this property has it all. Don't miss the opportunity to make this unique villa your own - contact us today for more details and to schedule a viewing.
This sophisticated 4-bedroom villa is now available for purchase within the exclusive confines of the Marbella Club Golf Resort, nestled amidst the picturesque hills of Benahavis. Surrounded by lush natural landscapes and upscale properties, this gated golf resort offers an unparalleled living experience. As an extension of the iconic Marbella Club Hotel, it exudes elegance, style, and pedigree. The resort features an 18-hole golf course designed by the legendary Dave Thomas, offering spectacular vistas of the Mediterranean Sea, Gibraltar, and the African coastline. Additionally, the resort boasts a Golf School, an exclusive Clubhouse, café and restaurant facilities, and a superb Equestrian center catering to major national and international events, along with extensive trekking areas.
The location is both enchanting and privileged, nestled in the lap of nature yet conveniently close to all amenities. Just a 20-minute drive from the Marbella Club Hotel and Puente Romano, as well as the luxurious amenities of Marbella's Golden Mile, it also offers easy access to sandy beaches, other golf courses, the vibrant Puerto Banus, San Pedro, Marbella, Estepona, and the gourmet village of Benahavis.
Set upon an expansive plot of 5,388 m², this contemporary-style villa offers 352 m² of built-up area and a 185 m² terrace space. It's a feast for the senses, boasting modern chic design and breathtaking vistas of the sea, majestic mountains, and verdant golf course. Upon entering the property, you'll be immediately captivated by the panoramic views that envelop you. The magnificent interior features 3 bedrooms, each meticulously designed for both aesthetics and functionality. Three modern bathrooms (all en-suite) are adorned with mirrors, luxurious fixtures, wooden cabinets, and vanity units, creating an immaculate and rejuvenating ambiance.
A cozy living room with a fireplace and abundant natural light provides a welcoming space for relaxation and socializing. Expansive sliding glass doors lead to a generous chill-out terrace with transparent balustrades, offering stunning views. The fully equipped minimalist-style kitchen boasts sleek design, an island, and top-of-the-line appliances, ideal for culinary enthusiasts and entertaining.
Designed with convenience in mind, the villa includes a private garage with 2 parking spaces, walk-in and fitted wardrobes, and a storage room, ensuring ample space for personal belongings. Outside, the landscaped gardens and impressive infinity saltwater swimming pool with sunbathing areas create an inviting outdoor oasis. A solarium beckons to bask in the warm sun while enjoying the captivating views.
Crafted for luxurious living and entertaining, this eco-friendly property is offered in excellent condition and tailored to the sophisticated Marbella lifestyle. It boasts luxury freestanding bathtubs, a floating staircase, LED lighting, double-glazing, air conditioning, and underfloor heating throughout the home.
Nestled in the serene beauty of Arenas, this captivating villa offers an unparalleled living experience. Boasting panoramic vistas of both the sea and mountains, this residence is a sanctuary of luxury and tranquility. This elegant villa spans 276m2, set on a spacious plot of 5502m2, all on one floor for seamless accessibility. Inside, three beautifully designed bedrooms provide ultimate comfort, complemented by two bathrooms, including a luxurious en-suite in the master bedroom. Constructed in 2004, the villa ensures modern amenities and quality craftsmanship. Relax and unwind in the inviting 5 x 10 metre pool, perfect for leisurely days, or immerse yourself in the grandeur of the living room with 5-meter tall ceilings, creating a sense of spaciousness and opulence. This villa also features underfloor heating, providing cozy warmth and comfort throughout all the rooms. Additional amenities include two charming wooden houses, one serving as a fully-equipped kitchen/laundry room, and the other as an extra bedroom, providing flexibility and convenience. Conveniently located just a 5-minute drive from the charming town of Arenas, the villa offers access to local amenities and services. Enjoy easy access to pristine beaches, with a short 15-20 minute drive bringing you to the captivating shores of the coast. Revel in the tranquility of the countryside while still being within reach of urban conveniences. This exceptional villa is an embodiment of luxury living, offering a harmonious blend of elegance, comfort, and natural beauty. Whether you seek a serene retreat or a stylish residence to entertain guests, this property fulfills every desire. Don't miss the opportunity to make this extraordinary villa your own! Contact us today to arrange a viewing and embark on the journey to owning your dream home in Arenas. We are pleased to be able to present this dream property to you soon, either personally or via virtual viewing. Because this world is unique - just like our Axarquía. In Andalusia. On the Costa del Sol. Here, on the sunny side of life...
Refurbished property of the highest quality, situated in the exclusive complex, LAS BRISAS COUNTRY CLUB.
This property is located in a complex of 18 neighbours, with a communal garden area so extensive, that it gives a unique privacy to the EXCLUSIVE neighbours who reside in this complex with its wonderful swimming pool.
The property is located on an attic floor, and the moment you enter the property you will notice the beautiful details, and the unique and exclusive quality with which it has been refurbished. It has home automation and aerothermics.
On the main floor there is a guest toilet, three large bedrooms with double wardrobes and en-suite bathrooms (one of them has a terrace with fabulous golf views), a laundry area, a beautiful open plan kitchen with top of the range appliances, a beautiful living room with fireplace and a terrace with wonderful views.
On the second floor we find a large room that can be used for guests, or as a second living room.
To all this we must add that the property has three underground parking spaces, and an important detail is that the lift is sized for two people.
The property has centralised hot and cold air conditioning.
Cannot find the property you are looking for? We have more Property search, please send us an email and let us know us what kind of properties you are interested on. You may also subscribe to our newsletter to receive information of new properties for sale in España.